package com.java1234.dao;

import java.sql.Connection;
import java.sql.ResultSet;

import com.java1234.model.Borrower;
import com.java1234.model.Librarian;
import com.java1234.model.SystemAdministrator;
import com.java1234.model.User;

public interface IUserDao {
	public User login(Connection con, User user) throws Exception;// 登录验证

	public ResultSet list(Connection con, User user) throws Exception;// 展示用户列表

	public int addBorrower(Connection con, Borrower borrower) throws Exception;// 往user表插入借阅者信息

	public int updateBorrower(Connection con, Borrower borrower) throws Exception;// 在user表修改借阅者信息

	public int deleteBorrower(Connection con, String borrowerAccount) throws Exception;// 在user表删除借阅者信息

	public int addLibrarian(Connection con, Librarian librarian) throws Exception;// 往user表增加图书管理员信息

	public int updateLibrarian(Connection con, Librarian librarian) throws Exception;// 在user表修改图书管理员信息

	public int deleteLibrarian(Connection con, String librarianAccount) throws Exception;// 在user表删除图书管理员信息

	public int addSystemAdministrator(Connection con, SystemAdministrator systemAdministrator) throws Exception;// 往user表增加系统管理员信息

	public int updateSystemAdministrator(Connection con, SystemAdministrator systemAdministrator) throws Exception;// 在user表修改系统管理员信息

	public int deleteSystemAdministrator(Connection con, String systemAdministratorAccount) throws Exception;// 在user表删除系统管理员信息
}
